Data Warehouse Methodology: A Process Driven Approach

The current methods of the development and implementation of a Data Warehouse (DW) don’t consider the integration with the business-processes (organizational-processes and theirs respective data). In addition to these current methods, based on demand-driven, data-driven and goal-driven, we will introduce in this paper a new approach to DW development and implementation. This new approach will be based on the integration of organizational processes and theirs data, denote by: Integrated-Process-Driven (IPD). The principles of this approach are based on the relationships between business-processes and Entity-Relationship-Models (ERM) (the data models of the Relational Database (RDB)). These relationships come from the methodology Architecture of Integrated Information Systems (ARIS). IPD will use the information comes from the data-driven, on the one side, to match (or define) the AS-IS business processes model. On the other side, IPD will use the information comes from the demand-driven (required by the DW users) to define the TO-BE business process model based also on the AS-IS model. IPD will integrate the new data models, comes from the TO-BE business processes model, with the DW requirements. The aim of IPD, is to define (or redefine) the organizational processes which will supply the DW with data. The added-value of this approach will be the integration of the previous methods (demand-driven and data-driven) with organizational processes that will treat these sets of informations to be used by the DW. Our approach is also a trigger for business processes reengineering and optimization. Finally, the goal-driven will verify if the IPD achieve the business goals.